leetcode-sql/medium/1355. Activity Participants.sql at main · cM2908/leetcode-sql · GitHub

Name: leetcode-sql/medium/1355. Activity Participants.sql at main · cM2908/leetcode-sql · GitHub
Rating: 4.7 (3975 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
WITH cte AS (
SELECT activity,COUNT(activity) AS cnt
FROM friends_1355
GROUP BY activity
),
cte1 AS (
SELECT activity,cnt,
MAX(cnt) OVER () AS max_cnt,
MIN(cnt) OVER () AS min_cnt
FROM cte
)
SELECT activity
FROM cte1
WHERE cnt <> max_cnt AND cnt <> min_cnt;